IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'spRegionSelect')
	BEGIN
		DROP  PROCEDURE  spRegionSelect
	END
GO
-- =============================================
-- Author:		<NamTP>
-- Create date: <Apr 24, 2012>
-- Description:	<Get Company List Infomation>
-- TEST: EXEC spRegionSelect
-- =============================================
CREATE PROCEDURE spRegionSelect
	
AS
BEGIN	
	SELECT RegionID,RegionDescription
    FROM Region
END
GO
